Guides and Tutorials

How to do the most common things in DataSort, one step at a time.

Start here

Short guides for the things people do most in DataSort, each filmed in the app as it is today. Pick a guide from the list, then play the video or follow the numbered steps.

Getting started

Edit your table

Work with sheets

Tidy your data

Ask the AI

Compare files

Export your data

Getting started

How to upload a spreadsheet in DataSort

Open an Excel, CSV or JSON file in DataSort.

Upload a spreadsheet in DataSort, the finished result

Watch on YouTube

Step by step

  1. Select File, or drop an Excel, CSV or JSON file onto the upload box.

    The DataSort upload box with the Select File button and the Try Sample Data link
  2. The file opens as a sheet you can read, edit and clean.

    A customer list opened in the DataSort table, one row per customer

Open DataSort

Getting started

How to clean a sheet with AI in DataSort

Fix names, dates, numbers and blank rows in one step.

Clean a sheet with AI in DataSort, the finished result

Watch on YouTube

Step by step

  1. Open your file. Mixed case names, dates in several formats and a title row all show as they are.

    A messy sales sheet with mixed case names, mixed date formats and a title row above the headers
  2. Select Clean this sheet.

    The Clean this sheet button above the sheet tabs
  3. The sheet comes back cleaned: names, emails, dates and countries each in one format.

    The cleaned sales sheet with consistent names, lower case emails, YYYY-MM-DD dates and full country names
  4. Below the table, What the AI fixed lists every change. Any change can be put back with one click.

    The What the AI fixed panel listing the corrected cells and removed rows

Open the AI Excel Cleaner

Getting started

How to pick up where you left off in DataSort

Your work is saved in this browser as you go. Save a copy under a name and open it again later.

Pick up where you left off in DataSort, the finished result

Watch on YouTube

Step by step

  1. Select Saved sessions. The latest version of your work is always there as Auto-saved.

    The Saved sessions list with the auto-saved workbook at the top
  2. Select Save current and give it a name, such as Q1 review.

    The Save window with the name Q1 review typed in
  3. Your named session is listed. Select it any time to open that workbook again.

    The Saved sessions list now showing the session named Q1 review

Open DataSort

Edit your table

How to edit a cell in DataSort

Change any value in the table by hand.

Watch on YouTube

Step by step

  1. Double click a cell, or point at it and select the pencil.

    A City cell open for editing in the DataSort table
  2. Press Enter to keep the change. Edited cells are marked, and Undo puts the old value back.

    The table with the edited City cell marked as changed

Open DataSort

Edit your table

How to add, duplicate or delete a row in DataSort

Insert a blank row anywhere, copy one, or remove one.

Watch on YouTube

Step by step

  1. Point at a row and select the plus sign beside it. Choose Insert row above, Insert row below or Duplicate this row.

    The row menu with Insert row above, Insert row below and Duplicate this row
  2. The copy appears right below and is highlighted until you change something else.

    The table with a duplicated row highlighted under the original
  3. To remove a row, point at it and select the bin. Undo brings it back.

    A row with its copy, duplicate and delete buttons showing

Open DataSort

Edit your table

How to add, rename or duplicate a column in DataSort

Insert a column, copy one with its values, or give a column a new name.

Watch on YouTube

Step by step

  1. Select the plus sign in a column heading. Choose Insert column left, Insert column right or Duplicate this column.

    The column menu with Insert column left, Insert column right and Duplicate this column
  2. Duplicate this column copies every value into a new column beside it.

    The table with a City copy column next to City
  3. Select the pencil in a heading to rename it. Type the new name and press Enter. The x hides a column.

    The City copy column heading being renamed to Office

Open DataSort

Edit your table

How to move a column in DataSort

Drag a column to where you want it.

Move a column in DataSort, the finished result

Watch on YouTube

Step by step

  1. Hold the grip at the left of a column heading.

    The pointer on the grip of the Country column heading
  2. Drag it onto another column and let go. Country now sits before Email.

    The table headings with Country moved in front of Email

Open DataSort

Edit your table

How to filter rows in DataSort

Show only the rows you want, by the values in a column.

Filter rows in DataSort, the finished result

Watch on YouTube

Step by step

  1. Select the funnel in a column heading to see every value in that column.

    The filter window for the Country column with each country listed
  2. Clear the list, then select the values you want to keep, such as United Kingdom.

    The Country filter with only United Kingdom selected
  3. Select Apply. The table shows only those rows, and the bar above names the filter so you can remove it.

    The table showing only United Kingdom rows, with the active filter named above it

Open DataSort

Edit your table

How to put rows in order by a column in DataSort

Arrange the rows from lowest to highest, or highest first, by any column.

Watch on YouTube

Step by step

  1. Select a column name, such as MRR. Rows go from lowest to highest.

    The table arranged by MRR from lowest to highest, with an up arrow in the heading
  2. Select it again for highest first. A third time puts the rows back in their original order.

    The table arranged by MRR from highest to lowest, with a down arrow in the heading

Open DataSort

Edit your table

How to undo and redo in DataSort

Take back any change, and bring it back again.

Watch on YouTube

Step by step

  1. Every change can be taken back. After an edit, the Undo button above the table lights up.

    The toolbar above the table with the Undo button available after a row was deleted
  2. Select Undo, or press Ctrl+Z (Cmd+Z on a Mac). Redo, or Ctrl+Y, puts the change back again.

    The table with the deleted row restored after Undo

Open DataSort

Edit your table

How to view the table full screen in DataSort

Give the table the whole screen and choose how many rows a page shows.

Step by step

  1. Select the full screen button at the right end of the toolbar.

    The full screen button at the right of the toolbar above the table
  2. The table fills the screen. Press Esc, or the same button, to leave.

    The table filling the whole screen
  3. In full screen, choose how many rows a page shows: 25, 50, 100 or all.

    The rows per page choice in full screen

Open DataSort

Edit your table

How to work with selected rows in DataSort

Select rows to copy, delete or export just those.

Work with selected rows in DataSort, the finished result

Watch on YouTube

Step by step

  1. Select the boxes at the start of the rows you want. Hold Shift to select a range.

    Three rows selected, with the bar above the table saying 3 rows selected
  2. Use the bar above the table: Copy, Delete, or Export to open the choice of file types.

    The export menu for the selected rows with Excel, CSV, JSON and SQL
  3. Choose a format. The file holds only the rows you selected.

    The table after the selected rows were exported to Excel

Open DataSort

Work with sheets

How to work with sheets in DataSort

Move between sheets, rename them, add a blank one, and see every sheet at once.

Watch on YouTube

Step by step

  1. Each sheet of your file is a tab above the table. Select a tab to open that sheet.

    The sheet tabs Q1 Sales, Q2 Sales and Account Reps with Q2 Sales open
  2. Double click a tab, or select its pencil, to rename it. Press Enter to keep the name.

    The Q2 Sales tab being renamed to April to June
  3. Select Add for a new blank sheet, a copy of this sheet, or another file as new tabs.

    The Add menu with New blank sheet, Duplicate this sheet and Add a file as new tabs
  4. With many sheets, the list button beside the tabs shows every sheet with its rows, so you can jump to any of them.

    The All sheets window listing each sheet with its row count

Open DataSort

Work with sheets

How to combine sheets into one table in DataSort

Stack several sheets or files into a single new tab.

Combine sheets into one table in DataSort, the finished result

Watch on YouTube

Step by step

  1. Open More sheet actions next to the tabs and choose Combine sheets into a new tab.

    The sheet actions menu with Combine sheets into a new tab
  2. Choose Keep every row, then select the sheets to combine.

    The Review and combine your sheets window with Keep every row chosen and two sales sheets selected
  3. Select Preview the combined sheet to see the columns you will get.

    The combine window showing What you will get, the nine columns of the combined sheet
  4. Select Confirm Merge. The rows open in a new Combined tab and the original sheets stay as they were.

    A new Combined tab beside Q1 Sales and Q2 Sales, holding the rows of both

Open Merge Excel Sheets

Tidy your data

How to remove duplicate rows in DataSort

Find repeated rows across a sheet and remove them in one step.

Remove duplicate rows in DataSort, the finished result

Watch on YouTube

Step by step

  1. Open AI Tools and choose Remove Duplicates.

    The AI Tools menu open with Remove Duplicates at the top
  2. Match on the whole row, or pick the columns that make two rows the same.

    The Remove duplicates window with Whole row and Specific columns options
  3. Select Remove duplicates. The sheet keeps one copy of each row.

    The sheet after duplicates were removed, with a lower row count on its tab

Open Remove Duplicate Rows

Tidy your data

How to find and replace in DataSort

Change a value everywhere it appears, in one sheet or all of them.

Find and replace in DataSort, the finished result

Watch on YouTube

Step by step

  1. Select Replace inside the search box above the table.

    The search box above the table with the Replace button at its right end
  2. Type what to find and what to replace it with. Every match is listed before anything changes.

    The Find and replace window changing W. Zhang to Wei Zhang, with the matching cells listed
  3. Select Replace. One step of Undo puts every cell back.

    The sheet after the replacement, with Wei Zhang in the Account Rep column

Open DataSort

Tidy your data

How to review what the AI fixed in DataSort

See every change the AI made, grouped by kind, and put any of them back.

Review what the AI fixed in DataSort, the finished result

Watch on YouTube

Step by step

  1. After a clean, What the AI fixed below the table lists every change, grouped by what was done.

    The What the AI fixed report with groups such as dates standardized and capitals corrected
  2. Open a group to see each cell before and after.

    A group of the report opened, showing original and corrected values side by side
  3. Put back the original value of any line, or a whole group, in one click. Select it again to restore the AI value.

    A line of the report put back to its original value, with a check mark beside it

Open DataSort

Tidy your data

How to extract and standardize in DataSort

Pull dates, phone numbers or emails into clean new columns in one format.

Extract and standardize in DataSort, the finished result

Watch on YouTube

Step by step

  1. Open AI Tools and choose Extract and Standardize.

    The AI Tools menu with Extract and Standardize
  2. Choose what to pull out: dates, phone numbers, emails, or all three.

    The Extract and Standardize window with Dates and Phone numbers selected
  3. Select Extract. New columns hold every value in one format, and your original columns stay as they were.

    The table with new standardized date and phone columns beside the originals

Open DataSort

Ask the AI

How to ask the AI assistant in DataSort

Tell the assistant what you want done to your data, and it makes the change.

Ask the AI assistant in DataSort, the finished result

Step by step

  1. Select AI Copilot at the bottom right to open the assistant beside your table.

    The AI assistant panel open beside the table with an empty message box
  2. Write what you want in plain words, such as add a column called Region and fill it with Europe, and send it.

    A request typed to the assistant to add a Region column filled with Europe
  3. The assistant makes the change, says what it did, and offers Undo right in the chat.

    The assistant reply with the finished step and an Undo button

Open DataSort

Ask the AI

How to choose the AI model in DataSort

Pick Auto, Fast, Classic, Smart or Deep for the assistant and the AI tools.

Step by step

  1. In the assistant, select the model name above the message box to see every model and what it is best for.

    The model menu listing Auto, Fast, Classic, Smart and Deep
  2. Choose one. Auto picks for you, and the same choice is in the AI Tools menu.

    The assistant with Smart chosen as the model

Read about the AI models

Ask the AI

How to find an earlier chat in DataSort

Your assistant chats are saved, one for each workbook, so you can read them again.

Find an earlier chat in DataSort, the finished result

Step by step

  1. In the assistant, select the clock at the top to list your earlier chats.

    The list of earlier assistant chats with this workbook marked
  2. Select a chat to read it again, with any reports it made.

    An earlier chat opened, showing the request and the assistant reply

Open DataSort

Ask the AI

How to get an AI Insights report in DataSort

A written report on your sheet with charts, every figure measured from your data.

Get an AI Insights report in DataSort, the finished result

Step by step

  1. Open AI Tools and choose Generate AI Insights.

    The AI Tools menu with Generate AI Insights
  2. The report opens beside your table, with totals, charts and what stands out.

    The AI Insights report with figure tiles and a chart beside the table
  3. Edit or remove any section, then Copy as Markdown or Save as PDF.

    A report section with its Edit and Remove buttons, and the Copy as Markdown and Save as PDF buttons

Open DataSort

Ask the AI

How to add map coordinates in DataSort

Turn a city or address column into latitude, longitude and a country code.

Add map coordinates in DataSort, the finished result

Step by step

  1. Open AI Tools and choose Augment with Geo-Data.

    The AI Tools menu with Augment with Geo-Data
  2. Choose the column with the place names. City is picked for you when there is one.

    The column picker with City selected
  3. Select Confirm. Latitude, Longitude and Country_Code columns are added for every row.

    The table with new Latitude, Longitude and Country_Code columns

Open DataSort

Compare files

How to compare two Excel files in DataSort

See every row and cell that changed between two versions of a spreadsheet.

Compare two Excel files in DataSort, the finished result

Step by step

  1. Add the first file, the older version, on the left.

    The compare page with products-october.xlsx added as the first file
  2. Add the newer version on the right. The comparison runs on its own.

    Both files added and the comparison showing changed, added and removed rows

Open Compare Excel Files

Compare files

How to compare two JSON files in DataSort

See every value that was added, removed or changed between two JSON documents.

Compare two JSON files in DataSort, the finished result

Step by step

  1. Paste the original JSON on the left, or select the upload button to open a file.

    The compare page with an order JSON loaded on the left
  2. Add the new version on the right. Every difference is listed by its path, such as status or items.

    The JSON comparison listing the changed status, email, quantity and the added item

Open Compare JSON

Export your data

How to export your data in DataSort

Download the sheet as Excel, CSV or JSON, or copy it.

Export your data in DataSort, the finished result

Step by step

  1. Open Export and choose Excel, CSV or JSON. The file downloads straight away.

    The Export menu with Excel, CSV, JSON and SQL options
  2. To export every sheet as one workbook, deselect Only this sheet first.

Open Convert CSV to Excel

Export your data

How to convert Excel to SQL in DataSort

Turn a sheet into SQL INSERT statements. Mid and Pro, or a Day Pass.

Convert Excel to SQL in DataSort, the finished result

Step by step

  1. Open Export and choose SQL.

    The Export menu with the SQL option highlighted
  2. A .sql file downloads with one INSERT statement per row, ready to run in your database.

    The confirmation that the sheet was exported to SQL

Open Convert Excel to SQL

Export your data

How to copy the table in DataSort

Copy the rows you see, ready to paste into Excel, Google Sheets or an email.

Step by step

  1. Select Copy above the table. The rows the table shows, with any filter applied, are copied to paste anywhere.

    The Copy button above the table, beside Export

Open DataSort