Import a Directory Listing into WPS Spreadsheets Without Splitting File Paths
Question details
The user needs to import a text file of directory listings into WPS Spreadsheets so each complete file path stays in one cell, and optionally separate the extension without splitting the path at every period.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A directory listing text file contains entries such as D:\Photos\1999\PIC00014.jpg and D:\Photos\1999\PIC00014.xmp; the user wants to load them for filename or metadata work.
- Observed behavior
- The import treats periods, tabs, or fixed-width positions as separators, causing file paths to split across columns or extensions to be omitted.
Before importing, open the text file in a plain text editor and note which delimiters, such as commas, tabs, semicolons, spaces, or periods, already appear inside the file paths. Choose a delimiter that does not occur in any path, or plan to import the file as a single column.
Import the entire directory listing into one column
Use this method when you want each complete path, including the extension, kept in a single cell without being split by periods or other characters.
WPS Spreadsheets can import text and CSV files through the Data tab. Selecting a delimiter that does not appear in the paths, or disabling delimiters, preserves the full path in one cell.
Click the Data tab in WPS Spreadsheets, then select From Text/CSV and choose the directory listing file.
In the import preview, choose a delimiter that is not present in the paths, such as Tab or Semicolon. If the paths do not contain tabs, selecting Tab keeps each row in one cell.
Set the data type to Text if available and click OK or Load to place the full paths into the worksheet.
Split the file extension after importing the complete path
Use this method when you need the base path in one column and the extension in another, but only after the full path has been imported intact.
Import directory listings cleanly with WPS Spreadsheets
Use WPS Spreadsheets to import text or CSV directory listings as a single column, then split extensions with formulas, without losing file path data or requiring Microsoft 365.
- 1. Download and open WPS Spreadsheets: Download WPS Office, launch WPS Spreadsheets, and open a blank workbook.
- 2. Import the directory listing file: Click the Data tab, choose From Text/CSV, select your directory listing file, and choose a delimiter that does not appear in the file paths.
- 3. Load the data into one column: Set the column data format to Text if available, then click Load to place each full path in a single cell.
- 4. Split the extension with formulas: Enter =TEXTBEFORE(A2,".",-1) and =TEXTAFTER(A2,".",-1) in adjacent columns if you need the base path and extension separated.

Frequently Asked Questions
Why does WPS Spreadsheets split my file paths when I import a directory listing?
The import dialog treats certain characters as delimiters. Periods, spaces, tabs, or fixed-width positions can be interpreted as column breaks. Use Data > From Text/CSV and select a delimiter that does not appear in the paths, or disable delimiters.
How do I keep the full file path in one cell during import?
In the import preview, choose a delimiter such as Tab or Semicolon only if it does not appear in the paths. If necessary, use a single-column import or set the column data format to Text before loading the data.
Can I separate the extension later without splitting folder periods?
Yes. First import the full path into one column. Then target the final period with formulas: =TEXTBEFORE(A2,".",-1) for the base path and =TEXTAFTER(A2,".",-1) for the extension, or use a helper-column formula for compatibility.
What if my WPS Spreadsheets version does not have TEXTBEFORE or TEXTAFTER?
Use a helper column to replace the last period with a temporary character, then split with LEFT, FIND, and MID. This avoids relying on newer functions and keeps earlier folder periods intact.
Does WPS Spreadsheets save the imported directory listing as an Excel-compatible file?
Yes. After importing and organizing the paths, save the workbook as .xlsx or .xls. WPS Spreadsheets maintains compatibility with Microsoft Excel formats.




