Live Preview
Table cells are editable. Click any cell to make changes.
Phables for Tables
Phables for Tables
Step-by-step guide to help you convert between table formats
First, let's select the "Data to Table Markup" tab if it's not already selected.
Click the "Data to Table Markup" button at the top of the page.
Drag and drop your file onto the upload area, or click to browse for a file.
The tool supports CSV, Excel (.xls, .xlsx), and OpenDocument (.ods) files.
First, select the "Paste your Data" option
Then you can paste data from your spreadsheet into the text area.
You can copy data from Excel, Google Sheets, or any other spreadsheet app and paste it directly.
Enter your Google Sheet's URL or ID in the input field.
Make sure your Google Sheet is publicly accessible (anyone with the link can view).
Optionally, you can specify a sheet name or GID if your spreadsheet has multiple sheets.
Then click the "Import Google Sheets" button.
Upload your SQLite database file (.db, .sqlite, .sqlite3).
Drag and drop your file onto the upload area, or click to browse.
After uploading, you'll be able to browse tables or enter a custom SQL query.
Click "Run Query" to execute your query.
Then click "Use This Result for Table Markup" to proceed.
Your data is now displayed in an editable preview table with a toolbar containing various tools.
The toolbar provides additional features:
Now, select the markup format you want to convert your data to:
Your table markup is now ready! You can copy it to the clipboard.
Click the "Copy" button that corresponds to your selected format.
You can also try different formats by selecting another format tab.
First, we'll select the "Table Markup to Data" tab if it's not already selected.
Choose the format of the table markup you want to convert:
Now, paste your table markup into the text area.
Make sure you're pasting into the correct format's text area.
For example, if you selected HTML format, paste into the HTML input area.
Your table has been converted to spreadsheet data.
You can see a preview of your data.
The CSV data is shown in the text area.
You have several options:
To edit an existing table, we'll first convert it to an editable format, make our changes, then convert it back.
First, let's select the "Table Markup to Data" tab.
Choose the format of your existing table:
Now, paste your existing table markup into the text area.
Make sure you've selected the correct format in the previous step.
Your table markup has been converted to data format.
Now, click the "Switch View" button to convert to an editable table.
This will take you to the "Data to Table Markup" view with your data loaded.
Now you can edit your table:
Now, select the markup format you want for your edited table:
Your edited table has been converted to the selected markup format.
Click the "Copy" button that corresponds to your selected format.
For example, if you chose HTML format, click the "Copy HTML" button.
First, let's load some sample data to showcase the advanced features.
Select the "Data to Table Markup" tab if it's not already selected.
Let's load some sample data to work with. This will allow us to demonstrate all the advanced editing features.
We'll use the CSV input area to load our sample data.
Would you like to use sample data for the demonstration?
to continue with the tutorialOnce the sample data is loaded, a table will appear that you can edit.
Let's explore the selection system, which allows you to select multiple cells for editing.
Click the "Selection Mode" button in the toolbar to enable selection mode.
In selection mode, you can:
Once you've selected cells, you can apply operations to all selected cells at once.
The history feature allows you to undo and redo changes to your table.
The History section in the toolbar has Undo and Redo buttons.
Try making some changes to your table, then:
You can also use keyboard shortcuts:
The column menu provides powerful operations for managing your table's columns.
Click the column menu button (⋮) in any column header to access column options:
You can also click the column header directly to sort the table by that column.
The Text formatter lets you transform text in your table cells.
Click the Text dropdown in the toolbar to see formatting options:
For each option, you can choose to apply it to:
The Actions menu provides powerful operations for your entire table.
Click the Fullscreen button to enter fullscreen mode, which gives you more space to work with large tables.
Click the Transpose button to swap rows and columns, turning row data into column data and vice versa.
Click the Cleanup dropdown for options to clean your data:
Let's learn how to clean up and format messy table data.
First, make sure you have a table loaded in the editor.
Click the "Data to Table Markup" tab if it's not already selected.
For this journey, we'll need some messy data to clean up. Let's load sample data with common issues:
We'll use the CSV input area to load our messy sample data.
Would you like to use messy sample data for the demonstration?
to continue with the tutorialOnce the sample data is loaded, we'll show you how to effectively clean it up.
The Cleanup menu provides tools for cleaning up messy data.
Click the Cleanup dropdown in the toolbar to see options:
These tools help you quickly clean up spreadsheet data before converting to table markup.
The Text menu helps you standardize the formatting of your text data.
Click the Text dropdown in the toolbar to see formatting options:
First, select a formatting operation:
Then, choose where to apply it:
You can sort your table data to organize it alphabetically or numerically.
Click the column menu button (⋮) in the header of the column you want to sort by.
In the menu, select either:
The table will automatically detect if your column contains text, numbers, or dates, and sort appropriately.
Transposing your table swaps rows and columns, which can be useful for certain data structures.
Click the Transpose button in the Actions section of the toolbar.
This action will:
This is particularly useful when you need to change the orientation of your data or when your source data is in the wrong orientation for your target format.
Selection mode allows you to edit multiple cells at once, which is useful for cleaning up data.
Click the Selection Mode button in the toolbar.
In selection mode:
This is particularly useful when you need to standardize formatting across many cells or remove unwanted data.
You've successfully completed the task!
Here are some additional features you might find useful:
If you need help in the future, just click the wizard button again.
You've successfully completed the task!
If you need help in the future, just click the wizard button again.