Ever tried to copy and paste a table from ChatGPT into a spreadsheet and realized the formatting was a total mess?

In this quick tech tutorial, we'll show you how to copy and paste from ChatGPT and clean up the formatting so your tables are ready to paste into your flashcard or glossary tool.

Cleaning up formatting on Google Sheets

1. Click the copy icon on ChatGPT
2. Create a new Google Sheet.
3. Click the top left cell.
4. Go to Edit > Paste (or CTRL/COMMAND + V)
5. Click "A" to select the first column.
6. Go to Data > Split text to columns
7. Change the Separator to "Custom" by clicking on "Detect automatically" and scrolling down to "Custom"
8. Type the vertical bar (|) character into the "Custom" text box
9. Clean up the spreadsheet, as needed.

Cleaning up formatting with Microsoft Excel

1. Click the copy icon on ChatGPT
2. Create a new Excel spreadsheet.
3. Click the top left cell.
4. Go to Edit > Paste (or CTRL/COMMAND + V)
5. Click "A" to select the first column.
6. Go to Data > Text to Columns
7. Click "Delimited."
8. Click Next.
9. Deselect Tab
10. Select Other
11. Type the vertical bar (|) character into the "Other" text box.
12. Click "Finish."
13. Clean up the spreadsheet, as needed.

Exporting a CSV file from ChatGPT

You can also get ChatGPT to convert the table into CSV format, then copy and paste that into a .csv document and upload that to another tool.

Here's how: https://www.youtube.com/watch?v=OE1LHwYfInM