File Format & Compatibility

How to Fix Barcode Data Changing When Copied from Google Sheets

Chanuka Geekiyanage Sep 30, 2026 868 views

Question details

The user wants to resolve an issue where barcode data gets altered or loses its format when transferred from Google Sheets to another application.

How to Prevent Barcode Data from Changing When Copied from Google Sheets

Product: Google Sheets
Device & OS: not provided
Scenario: Copying barcode values or cells from Google Sheets and pasting them into another software or document.
Observed behavior: The pasted barcode values appear as different data, plain numbers, or gibberish due to hidden web characters, formulas, or font incompatibilities.

Before you start

Verify that the destination application supports the specific barcode font you are using, and ensure that the font (such as Code 39 or EAN-13) is correctly installed on your local computer.

Solution 1Recommended

Use Paste Special to Copy Values Only

Using the Paste Special feature ensures that you strip away underlying formulas and web formatting, pasting only the raw barcode data.

Google Sheets often copies background HTML formatting, hidden characters, or formulas to the clipboard. By forcing the destination software to accept 'values only', you prevent these hidden elements from corrupting the barcode.

Copy the original data

Select the cells containing the barcodes in Google Sheets and press Ctrl + C (or Cmd + C on Mac) to copy them.

Navigate to the destination

Open the application or document where you want to place the barcode data.

Select Paste Special

Right-click the target area and look for a 'Paste special' option in the context menu.

Paste as values

Choose 'Values only' or 'Unformatted text' (often accessible via Ctrl + Shift + V) to paste the raw text.

Format Retention: Once the raw values are safely pasted, you may need to highlight the text and re-apply the barcode font manually in your destination app.

Solution 2

Use a Plain-Text Editor to Strip Formatting

Pasting data into an intermediary plain-text editor acts as a filter, removing all Google Sheets-specific formatting and revealing hidden characters.

Solution 3

Verify and Re-apply Barcode Fonts

Sometimes the data copies perfectly, but the destination application defaults to a standard font, making barcodes look like normal numbers.

Seamless Spreadsheet Management

Manage and Transfer Barcode Data Seamlessly in WPS Office

WPS Spreadsheet offers precise control over cell formatting, formulas, and local fonts. By managing your barcode data locally in WPS Office, you avoid web-clipboard formatting glitches and ensure accurate data transfer every time.

1. Open your data in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing your raw barcode values.
2. Copy the barcode data: Select the cells you wish to transfer and press Ctrl + C.
3. Navigate to the destination cell: Click on the cell or open the new document where the barcodes will be placed.
4. Use Paste Special: Right-click and select 'Paste Special', then choose 'Values' to prevent background formatting from transferring.
5. Apply local fonts: Highlight the newly pasted cells and select your barcode font from the WPS font dropdown menu.

Highly compatible with Microsoft Excel (.xlsx, .xls) and CSV formats.Supports installation and smooth application of local barcode fonts.Advanced Paste Special options handle raw data, formulas, and formatting separately.Lightweight, fast, and completely free to use for everyday spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my barcodes look like regular numbers when I paste them?

Barcodes are often standard alphanumeric characters formatted with a special barcode font. If the destination application does not have the font installed, or if the font formatting is lost during the copy-paste process, the data will revert to displaying as plain text or numbers.

Does losing format affect how barcode scanners read the printed data?

Yes. Barcode scanners rely on correct font rendering and specific start/stop characters (like asterisks in Code 39). If formatting strips these elements or alters the required character spacing, the physical scanner will not be able to read the printed barcode.

How do I reveal hidden characters copied from Google Sheets?

The easiest way to reveal hidden web-formatting characters is to paste the copied data into a plain-text editor like Notepad or TextEdit. This strips all rich text and table formatting, showing exactly what raw data is sitting on your clipboard.

Document & File Issues